{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["入力例","従事者情報入力シート","設定シート","種別_保育所等_計算結果シート","種別_小規模等_計算結果シート","種別_小規模Ｃ_計算結果シート","種別_家庭的_計算結果シート","種別_居宅訪問型_計算結果シート","エラーチェック (性別有)","集計シート","エラーチェック"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"入力例","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["■入力例　　★常勤換算の計算方法は、記入の手引きを参照してください。"]
[]
[null,"【保育所】"]
["　","●所定労働時間４０時間"]
[null,"●従事者","Aさん（男性）",null,"施設長                                     ",null,"週４０時間勤務"]
[null,null,"Bさん（女性）",null,"看護師                                     ",null,"週２０時間勤務"]
[null,null,"Cさん（女性）",null,"保育補助者                               ",null,"月１０時間勤務"]
[null,null,"Dさん（男性）",null,"保育士と事務員の兼務　　       　　　 ",null,"週４０時間勤務（保育士１０時間／事務員３０時間）"]
[null,null,"Eさん（女性）",null,"栄養士と調理員の兼務            　　　",null,"週３５時間勤務（栄養士１５時間／調理員２０時間）"]
[null,null,"Fさん（女性）",null,"調理員（併設施設との兼務）         ",null,"週４０時間勤務（９月末日の児童数：当施設４０名／併設施設２５名）"]
[null,null,"Gさん（男性）",null,"保育士（併設施設との兼務）         ",null,"週３０時間勤務（９月末日の児童数：当施設４０名／併設施設１０名）"]

{"sheet":"従事者情報入力シート","index":1,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,5],[3,1,4,10],[6,0,6,1],[6,2,6,3],[6,7,6,8],[8,0,8,1],[11,6,12,6],[11,7,12,7],[11,8,11,9],[11,10,12,10],[11,11,12,11]]}
[]
[null,"「社会福祉施設等調査」　常勤換算従事者数の計算補助ツール"]
[]
[]
[]
[]
["調査票種",null,"保育所・地域型保育事業所調査票",null,null,"サービス種別","サービス種別","選択してください",null,"サービス種別を選択してください"]
[]
["①施設・事業所の\n１週間の所定労働時間",null,null,"時間"]
[]
[null,"※任意","※必須","※必須","※必須",null,null,null,null,null,null,"入力不可"]
[null,"②自由記載\n（従事者名等入力してください）","③勤務形態\n（常勤専従／常勤兼務／非常勤）","④職種","⑤性別","⑥常勤専従\r\n人数","⑦この施設・\r\n事業所での､\r\n当該職種の\r\n1 週間の勤務時間","⑧月数回勤務の場合､\r\nこの施設・事業所での\r\n当該職種の\r\n1 か月の勤務時間","⑨勤務時間で分けられない場合､\r\n利用人数で按分",null,"⑩勤務時間でも利用人数でも分けられない場合､この施設・事業所の当該職種の換算数を直接入力","エラー"]
[null,null,null,null,null,null,null,null,"この施設・事業所の\n利用人数","兼務する施設・\n事業所の利用人数"]

{"sheet":"設定シート","index":2,"n_rows":68,"n_cols":26,"rows_kept":68,"cut":false,"hidden":true,"merged":[[2,12,2,16],[2,17,2,21],[3,13,3,14],[3,15,3,16],[3,18,3,19],[3,20,3,21]]}
["設定名","票種","性別選択有無","サービス表示有無","デフォルト種別",null,"調査票種名"]
["設定値","D",true,true,"選択してください",null,"保育所・地域型保育事業所調査票",null,null,null,null,null,null,null,null,null,null,null,"※性別の選択肢がある調査票のみ"]
[null,null,null,null,null,null,null,null,null,null,null,null,"男",null,null,null,null,"女"]
["ドロップダウンアイテム(基本)",null,null,null,null,null,"ドロップダウンアイテム(職種 - 資格)　+ 集計時の設定情報",null,null,null,null,null,"専従","常勤兼務",null,"非常勤",null,"専従","常勤兼務",null,"非常勤",null,null,"リストボックスに表示する職種一覧（非表示を除く）"]
["区分番号","区分名","選択肢","サービス種別","補足／シート名",null,"票種","サービス種別","職種-資格","集計用職種","集計用資格","備考","人数","人数","換算数","人数","換算数","人数","人数","換算数","人数","換算数",null,"票種","サービス種別","職種-資格"]
[1,"勤務形態","常勤専従",null,"C列",null,"D票","0400_2","1施設長","1施設長",null,null,"D8","D10","D12","D14","D16","D9","D11","D13","D15","D17"]
[1,"勤務形態","常勤兼務",null,"C列",null,"D票","0400_2","2保育士-該当資格なし","2保育士","該当資格なし",null,"E8","E10","E12","E14","E16","E9","E11","E13","E15","E17"]
[1,"勤務形態","非常勤",null,"C列",null,"D票","0400_2","2保育士-幼稚園教諭免許保有者","2保育士","幼稚園教諭免許保有者",null,"F8","F10","F12","F14","F16","F9","F11","F13","F15","F17"]
[2,"性別","男",null,"E列",null,"D票","0400_2","3保育補助者-該当資格なし","3保育補助者","該当資格なし",null,"G8","G10","G12","G14","G16","G9","G11","G13","G15","G17"]
[2,"性別","女",null,"E列",null,"D票","0400_2","3保育補助者-子育て支援員","3保育補助者","子育て支援員",null,"H8","H10","H12","H14","H16","H9","H11","H13","H15","H17"]
[9,"サービス種別","保育所、保育所型認定こども園、\n保育所型事業所内保育事業所","0400_2","種別_保育所等_計算結果シート",null,"D票","0400_2","4医師・歯科医師","4医師・歯科医師",null,null,"I8","I10","I12","I14","I16","I9","I11","I13","I15","I17"]
[9,"サービス種別","小規模保育事業所（Ａ型・Ｂ型）、小規模型事業所内保育事業所","0400_4","種別_小規模等_計算結果シート",null,"D票","0400_2","5保健師・看護師","5保健師・看護師",null,null,"J8","J10","J12","J14","J16","J9","J11","J13","J15","J17"]
[9,"サービス種別","小規模保育事業所（Ｃ型）","0400_6","種別_小規模Ｃ_計算結果シート",null,"D票","0400_2","6栄養士-該当資格なし","6栄養士","該当資格なし",null,"K8","K10","K12","K14","K16","K9","K11","K13","K15","K17"]
[9,"サービス種別","家庭的保育事業所","0400_7","種別_家庭的_計算結果シート",null,"D票","0400_2","6栄養士-管理栄養士","6栄養士","管理栄養士",null,"L8","L10","L12","L14","L16","L9","L11","L13","L15","L17"]
[9,"サービス種別","居宅訪問型保育事業所","0400_8","種別_居宅訪問型_計算結果シート",null,"D票","0400_2","7調理員","7調理員",null,null,"M8","M10","M12","M14","M16","M9","M11","M13","M15","M17"]
[null,null,null,null,null,null,"D票","0400_2","8事務員","8事務員",null,null,"N8","N10","N12","N14","N16","N9","N11","N13","N15","N17"]
[null,null,null,null,null,null,"D票","0400_2","9その他の職員","9その他の職員",null,null,"O8","O10","O12","O14","O16","O9","O11","O13","O15","O17"]
[null,null,null,null,null,null,"D票","0400_4","1管理者","1管理者",null,null,"D8","D10","D12","D14","D16","D9","D11","D13","D15","D17"]
[null,null,null,null,null,null,"D票","0400_4","2医師・歯科医師","2医師・歯科医師",null,null,"E8","E10","E12","E14","E16","E9","E11","E13","E15","E17"]
[null,null,null,null,null,null,"D票","0400_4","3保健師・看護師","3保健師・看護師",null,null,"F8","F10","F12","F14","F16","F9","F11","F13","F15","F17"]
[null,null,null,null,null,null,"D票","0400_4","4栄養士-該当資格なし","4栄養士","該当資格なし",null,"G8","G10","G12","G14","G16","G9","G11","G13","G15","G17"]
[null,null,null,null,null,null,"D票","0400_4","4栄養士-管理栄養士","4栄養士","管理栄養士",null,"H8","H10","H12","H14","H16","H9","H11","H13","H15","H17"]
[null,null,null,null,null,null,"D票","0400_4","5調理員","5調理員",null,null,"I8","I10","I12","I14","I16","I9","I11","I13","I15","I17"]
[null,null,null,null,null,null,"D票","0400_4","6事務員","6事務員",null,null,"J8","J10","J12","J14","J16","J9","J11","J13","J15","J17"]
[null,null,null,null,null,null,"D票","0400_4","7その他の職員-該当資格なし","7その他の職員","該当資格なし",null,"K8","K10","K12","K14","K16","K9","K11","K13","K15","K17"]
[null,null,null,null,null,null,"D票","0400_4","7その他の職員-子育て支援員","7その他の職員","子育て支援員",null,"L8","L10","L12","L14","L16","L9","L11","L13","L15","L17"]
[null,null,null,null,null,null,"D票","0400_4","8保育従事者-保育士資格あり","8保育従事者","保育士資格あり",null,"D24","D26","D28","D30","D32","D25","D27","D29","D31","D33"]
[null,null,null,null,null,null,"D票","0400_4","8保育従事者-保育士資格なし","8保育従事者（保育士資格なし）","該当資格なし",null,"E24","E26","E28","E30","E32","E25","E27","E29","E31","E33"]
[null,null,null,null,null,null,"D票","0400_4","8保育従事者-保育士資格なし-子育て支援員","8保育従事者（保育士資格なし）","子育て支援員",null,"F24","F26","F28","F30","F32","F25","F27","F29","F31","F33"]
[null,null,null,null,null,null,"D票","0400_6","1管理者","1管理者",null,null,"D8","D10","D12","D14","D16","D9","D11","D13","D15","D17"]
[null,null,null,null,null,null,"D票","0400_6","2医師・歯科医師","2医師・歯科医師",null,null,"E8","E10","E12","E14","E16","E9","E11","E13","E15","E17"]
[null,null,null,null,null,null,"D票","0400_6","3保健師・看護師","3保健師・看護師",null,null,"F8","F10","F12","F14","F16","F9","F11","F13","F15","F17"]
[null,null,null,null,null,null,"D票","0400_6","4栄養士-該当資格なし","4栄養士","該当資格なし",null,"G8","G10","G12","G14","G16","G9","G11","G13","G15","G17"]
[null,null,null,null,null,null,"D票","0400_6","4栄養士-管理栄養士","4栄養士","管理栄養士",null,"I8","I10","I12","I14","I16","I9","I11","I13","I15","I17"]
[null,null,null,null,null,null,"D票","0400_6","5調理員","5調理員",null,null,"K8","K10","K12","K14","K16","K9","K11","K13","K15","K17"]
[null,null,null,null,null,null,"D票","0400_6","6事務員","6事務員",null,null,"L8","L10","L12","L14","L16","L9","L11","L13","L15","L17"]
[null,null,null,null,null,null,"D票","0400_6","7その他の職員-該当資格なし","7その他の職員","該当資格なし",null,"M8","M10","M12","M14","M16","M9","M11","M13","M15","M17"]
[null,null,null,null,null,null,"D票","0400_6","7その他の職員-子育て支援員","7その他の職員","子育て支援員",null,"N8","N10","N12","N14","N16","N9","N11","N13","N15","N17"]
[null,null,null,null,null,null,"D票","0400_6","9家庭的保育者-保育士資格あり","9家庭的保育者","保育士資格あり",null,"K24","K26","K28","K30","K32","K25","K27","K29","K31","K33"]
[null,null,null,null,null,null,"D票","0400_6","9家庭的保育者-保育士資格なし","9家庭的保育者（保育士資格なし）","該当資格なし",null,"L24","L26","L28","L30","L32","L25","L27","L29","L31","L33"]
[null,null,null,null,null,null,"D票","0400_6","9家庭的保育者-保育士資格なし-子育て支援員","9家庭的保育者（保育士資格なし）","子育て支援員",null,"M24","M26","M28","M30","M32","M25","M27","M29","M31","M33"]
[null,null,null,null,null,null,"D票","0400_6","10家庭的保育補助者-該当資格なし","10家庭的保育補助者","該当資格なし",null,"N24","N26","N28","N30","N32","N25","N27","N29","N31","N33"]
[null,null,null,null,null,null,"D票","0400_6","10家庭的保育補助者-子育て支援員","10家庭的保育補助者","子育て支援員",null,"O24","O26","O28","O30","O32","O25","O27","O29","O31","O33"]
[null,null,null,null,null,null,"D票","0400_7","1管理者","1管理者",null,null,"D8","D10","D12","D14","D16","D9","D11","D13","D15","D17"]
[null,null,null,null,null,null,"D票","0400_7","2医師・歯科医師","2医師・歯科医師",null,null,"E8","E10","E12","E14","E16","E9","E11","E13","E15","E17"]
[null,null,null,null,null,null,"D票","0400_7","3保健師・看護師","3保健師・看護師",null,null,"F8","F10","F12","F14","F16","F9","F11","F13","F15","F17"]
[null,null,null,null,null,null,"D票","0400_7","4栄養士-該当資格なし","4栄養士","該当資格なし",null,"G8","G10","G12","G14","G16","G9","G11","G13","G15","G17"]
[null,null,null,null,null,null,"D票","0400_7","4栄養士-管理栄養士","4栄養士","管理栄養士",null,"H8","H10","H12","H14","H16","H9","H11","H13","H15","H17"]
[null,null,null,null,null,null,"D票","0400_7","5調理員","5調理員",null,null,"I8","I10","I12","I14","I16","I9","I11","I13","I15","I17"]
[null,null,null,null,null,null,"D票","0400_7","6事務員","6事務員",null,null,"J8","J10","J12","J14","J16","J9","J11","J13","J15","J17"]
[null,null,null,null,null,null,"D票","0400_7","7その他の職員-該当資格なし","7その他の職員","該当資格なし",null,"D22","D24","D26","D28","D30","D23","D25","D27","D29","D31"]
[null,null,null,null,null,null,"D票","0400_7","7その他の職員-子育て支援員","7その他の職員","子育て支援員",null,"E22","E24","E26","E28","E30","E23","E25","E27","E29","E31"]
[null,null,null,null,null,null,"D票","0400_7","8家庭的保育者-保育士資格あり","8家庭的保育者","保育士資格あり",null,"F22","F24","F26","F28","F30","F23","F25","F27","F29","F31"]
[null,null,null,null,null,null,"D票","0400_7","8家庭的保育者-保育士資格なし","8家庭的保育者（保育士資格なし）","該当資格なし",null,"G22","G24","G26","G28","G30","G23","G25","G27","G29","G31"]
[null,null,null,null,null,null,"D票","0400_7","8家庭的保育者-保育士資格なし-子育て支援員","8家庭的保育者（保育士資格なし）","子育て支援員",null,"H22","H24","H26","H28","H30","H23","H25","H27","H29","H31"]
[null,null,null,null,null,null,"D票","0400_7","9家庭的保育補助者-該当資格なし","9家庭的保育補助者","該当資格なし",null,"I22","I24","I26","I28","I30","I23","I25","I27","I29","I31"]
[null,null,null,null,null,null,"D票","0400_7","9家庭的保育補助者-子育て支援員","9家庭的保育補助者","子育て支援員",null,"J22","J24","J26","J28","J30","J23","J25","J27","J29","J31"]
[null,null,null,null,null,null,"D票","0400_8","1管理者","1管理者",null,null,"D8","D10","D12","D14","D16","D9","D11","D13","D15","D17"]
[null,null,null,null,null,null,"D票","0400_8","2医師・歯科医師","2医師・歯科医師",null,null,"E8","E10","E12","E14","E16","E9","E11","E13","E15","E17"]
[null,null,null,null,null,null,"D票","0400_8","3保健師・看護師","3保健師・看護師",null,null,"F8","F10","F12","F14","F16","F9","F11","F13","F15","F17"]
[null,null,null,null,null,null,"D票","0400_8","4栄養士-該当資格なし","4栄養士","該当資格なし",null,"G8","G10","G12","G14","G16","G9","G11","G13","G15","G17"]
[null,null,null,null,null,null,"D票","0400_8","4栄養士-管理栄養士","4栄養士","管理栄養士",null,"H8","H10","H12","H14","H16","H9","H11","H13","H15","H17"]
[null,null,null,null,null,null,"D票","0400_8","5事務員","事務員",null,null,"I8","I10","I12","I14","I16","I9","I11","I13","I15","I17"]
[null,null,null,null,null,null,"D票","0400_8","6その他の職員-該当資格なし","6その他の職員","該当資格なし",null,"J8","J10","J12","J14","J16","J9","J11","J13","J15","J17"]
[null,null,null,null,null,null,"D票","0400_8","6その他の職員-子育て支援員","6その他の職員","子育て支援員",null,"K8","K10","K12","K14","K16","K9","K11","K13","K15","K17"]
[null,null,null,null,null,null,"D票","0400_8","7居宅訪問型保育者-保育士資格あり","居宅訪問型保育者","保育士資格あり",null,"L8","L10","L12","L14","L16","L9","L11","L13","L15","L17"]
[null,null,null,null,null,null,"D票","0400_8","7居宅訪問型保育者-保育士資格なし","居宅訪問型保育者（保育士資格なし）","該当資格なし",null,"M8","M10","M12","M14","M16","M9","M11","M13","M15","M17"]
[null,null,null,null,null,null,"D票","0400_8","7居宅訪問型保育者-資格なし-子育て支援員","居宅訪問型保育者（保育士資格なし）","子育て支援員",null,"N8","N10","N12","N14","N16","N9","N11","N13","N15","N17"]

{"sheet":"種別_保育所等_計算結果シート","index":3,"n_rows":17,"n_cols":15,"rows_kept":17,"cut":false,"hidden":true,"merged":[[11,1,12,1],[13,0,14,1],[15,1,16,1],[5,10,6,10],[5,12,6,12],[5,13,6,13],[5,14,6,14],[7,0,8,1],[9,0,10,1],[5,0,6,2],[5,3,6,3],[5,4,6,4],[5,6,6,6],[5,8,6,8],[5,9,6,9]]}
["●計算結果シート　D票　　＜保育所（保育所型認定こども園含む）、保育所型事業所内保育事業所（定員20人以上）＞"]
["※この内容を調査票に転記してください。"]
[]
[]
["■保育所（保育所型認定こども園を含む）、保育所型事業所内保育事業所（定員20人以上）"]
[null,null,null,"1　施設長","2　保育士",null,"３　保育補助者",null,"4　医師・\n    歯科医師","5　保健師・\n  看護師","6　栄養士",null,"7　調理員","8　事務員","9　その他の職員"]
[null,null,null,null,null,"2のうち \n幼稚園教諭\n免許保有者",null,"3のうち\n子育て支援員",null,null,null,"6のうち\n管理栄養士"]
["常勤専従",null,"男"]
[null,null,"女"]
["常勤兼務",null,"男"]
[null,null,"女"]
[null,"常勤兼務の換算数","男"]
[null,null,"女"]
["非常勤",null,"男"]
[null,null,"女"]
[null,"非常勤の換算数","男"]
[null,null,"女"]

{"sheet":"種別_小規模等_計算結果シート","index":4,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":true,"merged":[[21,11,22,11],[23,0,24,1],[25,0,26,1],[27,1,28,1],[29,0,30,1],[20,10,22,10],[31,1,32,1],[15,1,16,1],[20,0,22,2],[20,3,20,5],[20,7,20,9],[21,3,22,3],[21,4,22,4],[21,7,22,7],[21,8,22,8],[5,9,6,9],[5,10,6,10],[7,0,8,1],[9,0,10,1],[11,1,12,1],[5,6,6,6],[5,8,6,8],[13,0,14,1],[5,0,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5]]}
["●計算結果シート　D票　　＜小規模保育事業所（A型・B型）、小規模型事業所内保育事業所（定員19人以下）＞"]
["※この内容を調査票に転記してください。"]
[]
["■（Ａ型・Ｂ型）、小規模型事業所内保育事業所（定員19人以下）"]
[]
[null,null,null,"1　管理者","２　医師・\n 　歯科医師","３　保健師・\n　　看護師","4　栄養士",null,"５　調理員","６　事務員","７　その他の職員"]
[null,null,null,null,null,null,null,"4のうち\n管理栄養士",null,null,null,"7のうち\n子育て支援員"]
["常勤専従",null,"男"]
[null,null,"女"]
["常勤兼務",null,"男"]
[null,null,"女"]
[null,"常勤兼務の換算数","男"]
[null,null,"女"]
["非常勤",null,"男"]
[null,null,"女"]
[null,"非常勤の換算数","男"]
[null,null,"女"]
[]
["■（Ａ型・Ｂ型）、小規模型事業所内保育事業所（定員19人以下）",null,null,null,null,null,null,"■Ｃ型"]
[]
[null,null,null,"８　保育従事者",null,null,null,"９　家庭的保育者",null,null,"10  家庭的\n     保育補助者"]
[null,null,null,"保育士資格あり","保育士資格なし",null,null,"保育士資格あり","保育士資格なし",null,null,"10のうち\n子育て支援員"]
[null,null,null,null,null,"う ち\n子育て支援員",null,null,null,"うち\n子育て支援員"]
["常勤専従",null,"男"]
[null,null,"女",null,null,null,null,null,null,null,0,0]
["常勤兼務",null,"男"]
[null,null,"女",null,null,null,null,0,0,0,0,0]
[null,"常勤兼務の換算数","男"]
[null,null,"女",null,null,null,null,null,0,0,0,0]
["非常勤",null,"男"]
[null,null,"女"]
[null,"非常勤の換算数","男"]
[null,null,"女",null,null,null,null,0,0,0,0,0]

{"sheet":"種別_小規模Ｃ_計算結果シート","index":5,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":true,"merged":[[11,1,12,1],[5,0,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5],[5,11,6,11],[5,12,6,12],[6,8,6,9],[7,0,8,1],[9,0,10,1],[5,6,6,7],[5,10,6,10],[21,14,22,14],[13,0,14,1],[15,1,16,1],[20,0,22,2],[20,3,20,5],[20,7,22,9],[20,10,20,12],[20,13,22,13],[21,3,22,3],[21,4,22,4],[21,10,22,10],[21,11,22,11],[29,0,30,1],[29,7,30,8],[31,1,32,1],[31,8,32,8],[23,0,24,1],[23,7,24,8],[25,0,26,1],[25,7,26,8],[27,1,28,1],[27,8,28,8]]}
["●計算結果シート　D票　　＜小規模保育事業所（C型）＞"]
["※この内容を調査票に転記してください。"]
[]
["■（Ｃ型）"]
[]
[null,null,null,"1 管理者","  　２ 医師・\n 　　　 歯科医師","　　３　保健師・\n　　　　 看護師","　　　４ 栄養士",null,null,null,"５ 調理員","６ 事務員","７　その他の\n   職員"]
[null,null,null,null,null,null,null,null,"4のうち\n 管理栄養士",null,null,null,null,"7のうち\n子育て支援員"]
["常勤専従",null,"男"]
[null,null,"女"]
["常勤兼務",null,"男"]
[null,null,"女"]
[null,"常勤兼務\nの換算数","男"]
[null,null,"女"]
["非常勤",null,"男"]
[null,null,"女"]
[null,"非常勤\nの換算数","男"]
[null,null,"女"]
[]
["■Ａ型・Ｂ型、小規模型事業所内保育事業所（定員19人以下）",null,null,null,null,null,null,null,"■Ｃ型"]
[]
[null,null,null,"８　保育従事者",null,null,null,null,null,null,"９　家庭的保育者",null,null,"  10  家庭的\n       保育補助者"]
[null,null,null,"保育士資格あり","保育士資格なし",null,null,null,null,null,"保育士資格あり","保育士資格なし",null,null,"10のうち\n子育て支援員"]
[null,null,null,null,null,"う ち\n子育て支援員",null,null,null,null,null,null,"うち\n子育て支援員"]
["常勤専従",null,"男",null,null,null,null,"常勤専従",null,"男"]
[null,null,"女",null,null,null,null,null,null,"女"]
["常勤兼務",null,"男",null,null,null,null,"常勤兼務",null,"男"]
[null,null,"女",null,null,null,null,null,null,"女"]
[null,"常勤兼務\nの換算数","男",null,null,null,null,null,"常勤兼務\nの換算数","男"]
[null,null,"女",null,null,null,null,null,null,"女"]
["非常勤",null,"男",null,null,null,null,"非常勤",null,"男"]
[null,null,"女",null,null,null,null,null,null,"女"]
[null,"非常勤\nの換算数","男",null,null,null,null,null,"非常勤\nの換算数","男"]
[null,null,"女",null,null,null,null,null,null,"女"]

{"sheet":"種別_家庭的_計算結果シート","index":6,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":true,"merged":[[19,9,20,9],[21,0,22,1],[23,0,24,1],[25,1,26,1],[27,0,28,1],[29,1,30,1],[18,0,20,2],[18,3,20,3],[18,5,18,7],[18,8,20,8],[19,4,20,4],[19,5,20,5],[19,6,20,6],[5,9,6,9],[7,0,8,1],[9,0,10,1],[11,1,12,1],[13,0,14,1],[5,6,6,6],[5,8,6,8],[15,1,16,1],[5,0,6,2],[5,3,6,3],[5,4,6,4],[5,5,6,5]]}
["●計算結果シート　D票　　＜家庭的保育事業所＞"]
["※この内容を調査票に転記してください。"]
[]
["■家庭的保育事業所"]
[]
[null,null,null,"1　管理者","  ２　医師・\n 　 歯科医師","３　保健師・\n　　看護師","４　栄養士",null,"５　調理員","６　事務員"]
[null,null,null,null,null,null,null,"4のうち\n管理栄養士"]
["常勤専従",null,"男"]
[null,null,"女"]
["常勤兼務",null,"男"]
[null,null,"女"]
[null,"常勤兼務の換算数","男"]
[null,null,"女"]
["非常勤",null,"男"]
[null,null,"女"]
[null,"非常勤の換算数","男"]
[null,null,"女"]
[]
[null,null,null,"７　その他の職員",null,"８　家庭的保育者",null,null,"９　家庭的保育\n　　 　補助者"]
[null,null,null,null,"７のうち\n子育て支援員","保育士資格あり","保育士資格なし",null,null,"9のうち\n子育て支援員"]
[null,null,null,null,null,null,null,"うち\n子育て支援員"]
["常勤専従",null,"男"]
[null,null,"女"]
["常勤兼務",null,"男"]
[null,null,"女"]
[null,"常勤兼務の換算数","男"]
[null,null,"女"]
["非常勤",null,"男"]
[null,null,"女"]
[null,"非常勤の換算数","男"]
[null,null,"女"]

{"sheet":"種別_居宅訪問型_計算結果シート","index":7,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":true,"merged":[[7,0,8,1],[9,0,10,1],[11,1,12,1],[13,0,14,1],[15,1,16,1],[4,9,6,9],[4,11,4,13],[5,7,6,7],[5,10,6,10],[5,11,6,11],[5,12,6,12],[4,8,6,8],[4,0,6,2],[4,3,6,3],[4,4,6,4],[4,5,6,5],[4,6,6,6]]}
["●計算結果シート　D票　　＜居宅訪問型保育事業所＞"]
["※この内容を調査票に転記してください。"]
[]
["■居宅訪問型保育事業所"]
[null,null,null,"１　管理者","２　医師・\n   歯科医師","３　保健師・\n    看護師","４　栄養士",null,"５　事務員","６　その他の職員",null,"７　居宅訪問型保育者"]
[null,null,null,null,null,null,null,"4のうち\n管理栄養士",null,null,"６のうち\n子育て支援員","保育士資格あり","保育士資格なし"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"うち\n子育て支援員"]
["常勤専従",null,"男"]
[null,null,"女"]
["常勤兼務",null,"男"]
[null,null,"女"]
[null,"常勤兼務の換算数","男"]
[null,null,"女"]
["非常勤",null,"男"]
[null,null,"女"]
[null,"非常勤の換算数","男"]
[null,null,"女"]

{"sheet":"エラーチェック (性別有)","index":8,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["2024.5.14","性別有の場合、項目番号がずれるため、エラーメッセージもそれに対応したもの（２０２１年度より採用）"]
[null,"勤務時間①-④の入力値は①＞②＞③＞④　※チェック時に優先度の高い有効値がある場合は、それより低い優先度の値のチェックは不要とする"]
[]
["エラーコード一覧",null,null,"エラーチェック　入力規則"]
["MSGCD","エラー表示メッセージ",null,"番号","項目","対象列\nセル","チェック種類","入力値種類","スタイル","チェック内容","MSGCD","エラー表示メッセージ","表示場所","集計結果","備考","確認"]
["MSG_CHK_ERR_K(1)","リストから選択してください",null,1,"サービス種別","Ｈ7","入力規則","リスト","停止","選択肢以外","MSG_CHK_ERR_K(1)",{"$f":"IF(ISERROR(VLOOKUP(K6,$A$6:$B$38,2,0))=TRUE,\"\",VLOOKUP(K6,$A$6:$B$38,2,0))","v":"リストから選択してください"},"メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(2)","1週間の所定労働時間は32～44の数値で入力してください",null,2,"１週間の所定労働時間","C9","入力規則","小数点数","停止","≠小数\n範囲：1-44","MSG_CHK_ERR_K(2)","1週間の所定労働時間は32～44の数値で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(3)","１週間の勤務時間は1～44の数値で入力してください",null,3,"勤務形態","C列","入力規則","リスト","停止","選択肢以外","MSG_CHK_ERR_K(9)","勤務形態はリストから選択してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(4)","人数は0～99999の整数で入力してください",null,4,"職種","D列","入力規則","リスト","停止","選択肢以外","MSG_CHK_ERR_P(7)","職種はリストから選択してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(5)","１職種あたりの換算数は0.1～1.0の数値で入力してください",null,5,"性別","E列","入力規則","リスト","停止","未記入","MSG_CHK_ERR_K(8)","性別はリストから選択してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(6)","1か月の勤務時間は1～176の数値で入力してください",null,6,"⑤常勤専従人数","Ｆ列","入力規則","整数","停止","≠整数\n範囲：1～99999","MSG_CHK_ERR_K(7)","人数は1～99999の整数で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(7)","人数は1～99999の整数で入力してください",null,7,"⑥この施設での１週間の勤務時間","G列","入力規則","小数点数","停止","≠小数\n範囲：1-44","MSG_CHK_ERR_K(3)","１週間の勤務時間は1～44の数値で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","所定労働時間とのチェックはプログラムで対応\n値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(8)","性別はリストから選択してください",null,8,"⑦1か月に数回の勤務の場合の１か月の勤務時間","H列","入力規則","小数点数","停止","≠小数\n範囲：1-176","MSG_CHK_ERR_K(6)","1か月の勤務時間は1～176の数値で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","所定労働時間とのチェックはプログラムで対応\n値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(9)","勤務形態はリストから選択してください",null,9,"⑧勤務時間が分けられない場合","I列・J列","入力規則","整数","停止","≠整数\n範囲：0～99999","MSG_CHK_ERR_K(4)","人数は0～99999の整数で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","整数のみ 介護（I、J列）、福祉（I列）\n値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
[null,null,null,10,"⑧勤務時間が分けられない場合","I列","入力規則","整数","停止","≠整数\n範囲：1～99999","MSG_CHK_ERR_K(7)","人数は1～99999の整数で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","整数のみ 福祉\n値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
[null,null,null,11,"⑨当該職種の換算数","K列","入力規則","小数点数","停止","＞１．０\n範囲：0.1～1","MSG_CHK_ERR_K(5)","１職種あたりの換算数は0.1～1.0の数値で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_P(1)","エラーが発生しています　(集計不可)"]
["MSG_CHK_ERR_P(2)","エラーが発生しています　(集計結果はエラー行を除外しています)"]
["MSG_CHK_ERR_P(3)","サービス種別を選択してください",null,"エラーチェック　プログラム"]
["MSG_CHK_ERR_P(4)","1週間の所定労働時間は32～44の数値で入力してください",null,"番号","項目","対象列\nセル","チェック種類","入力値種類","スタイル","チェック内容","MSGCD","エラー表示メッセージ","表示場所","集計結果","備考","確認"]
["MSG_CHK_ERR_P(5)","勤務形態をリストから選択してください",null,1,"全体","全体","プログラム",null,null,"エラーが1つ以上発生している場合\n※集計不可のエラーが含まれている場合","MSG_CHK_ERR_P(1)",{"$f":"IF(ISERROR(VLOOKUP(K21,$A$6:$B$46,2,0))=TRUE,\"\",VLOOKUP(K21,$A$6:$B$46,2,0))","v":"エラーが発生しています　(集計不可)"},"セル「G9」","全ての集計結果が算出不可","プログラムチェック結果で1つ以上のエラーが発生している場合に表示する\n「サービス種別」・「1週間の所定労働時間」のブランクエラーを含む場合","メッセージ確認"]
["MSG_CHK_ERR_P(6)","職種をリストから選択してください",null,2,"全体","全体","プログラム",null,null,"エラーが1つ以上発生している場合\n※集計不可のエラーが含まれていない場合","MSG_CHK_ERR_P(2)",{"$f":"IF(ISERROR(VLOOKUP(K22,$A$6:$B$46,2,0))=TRUE,\"\",VLOOKUP(K22,$A$6:$B$46,2,0))","v":"エラーが発生しています　(集計結果はエラー行を除外しています)"},"セル「G9」","該当行は集計結果から除外","プログラムチェック結果で1つ以上のエラーが発生している場合に表示する\n※行単位のエラーのみの場合","メッセージ確認"]
["MSG_CHK_ERR_P(7)","職種はリストから選択してください",null,3,"サービス種別","Ｈ7","プログラム",null,null,"未記入","MSG_CHK_ERR_P(3)","サービス種別を選択してください","セル「J7」","全ての集計結果が算出不可","サービス種別が複数ある調査票種のみ\n※サービス種別の選択が不要な票種は不要","サービス種別がブランクの場合の集計ができない旨を確認"]
["MSG_CHK_ERR_P(8)","性別をリストから選択してください",null,4,"１週間の所定労働時間","C9","プログラム",null,null,"未記入","MSG_CHK_ERR_P(4)","1週間の所定労働時間は32～44の数値で入力してください","セル「C10」","全ての集計結果が算出不可",null,"所定労働時間がブランクの場合の集計ができない旨を確認"]
["MSG_CHK_ERR_P(9)","⑦勤務時間は所定労働時間以下の数値を入力してください",null,5,"１週間の所定労働時間","C9","プログラム",null,null,"≠小数点第２位以内","MSG_CHK_ERR_P(11)","小数点第２位以内の数値を入力してください","セル「C10」","全ての集計結果が算出不可",null,"所定労働時間がブランクの場合の集計ができない旨を確認"]
["MSG_CHK_ERR_P(10)","⑧勤務時間は「所定労働時間ｘ４」以下の数値を入力してください",null,6,"勤務形態","C列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(5)","勤務形態をリストから選択してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"メッセージ確認"]
["MSG_CHK_ERR_P(11)","小数点第２位以内の数値を入力してください",null,7,"職種","D列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(6)","職種をリストから選択してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態入力時"]
["MSG_CHK_ERR_P(12)","小数点第３位以内の数値を入力してください",null,8,"職種","D列","プログラム",null,null,"選択されたサービス種別に該当しない職種の場合","MSG_CHK_ERR_P(7)","職種はリストから選択してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","サービス種別を後で変更したケースに対応","チェックの追加を確認\n勤務形態入力時"]
["MSG_CHK_ERR_P(13)","⑨人数は両方入力してください",null,9,"性別","E列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(8)","性別をリストから選択してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","性別の選択が不要な票はチェック不要\n※列幅を0で非表示対応とする","2021.から実稼働"]
["MSG_CHK_ERR_P(14)","⑦～⑩が未入力です",null,10,"⑥この施設での１週間の勤務時間","Ｇ列","プログラム",null,null,"≧所定労働時間","MSG_CHK_ERR_P(9)","⑦勤務時間は所定労働時間以下の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","入力規則では対応不可\n→プログラムで対応（1～44までは入力規則で対応、そうでない場合プログラムで対応）","入力規則からプログラムでのチェックに変更\n勤務形態：常勤兼務の時"]
["MSG_CHK_ERR_P(15)","常勤専従の人数が未入力です",null,11,"⑥この施設での１週間の勤務時間","Ｇ列","プログラム",null,null,">所定労働時間","MSG_CHK_ERR_P(24)","⑦勤務時間は所定労働時間より小さい数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","入力規則では対応不可\n→プログラムで対応（1～44までは入力規則で対応、そうでない場合プログラムで対応）","入力規則からプログラムでのチェックに変更\n勤務形態：非常勤の時"]
["MSG_CHK_ERR_P(16)","常勤専従は常勤専従人数のみ入力してください",null,12,"⑥この施設での１週間の勤務時間","Ｇ列","プログラム",null,null,"≠小数点第２位以内","MSG_CHK_ERR_P(11)","小数点第２位以内の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","小数点以下の入力規則はできない為、チェックを追加","チェックの追加を確認\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(17)","常勤専従は⑦～⑩の入力は不要です",null,13,"⑦1か月に数回の勤務の場合の１か月の勤務時間","Ｈ列","プログラム",null,null,"≧所定労働時間×４","MSG_CHK_ERR_P(10)","⑧勤務時間は「所定労働時間ｘ４」以下の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","入力規則では対応不可\n→プログラムで対応（1～176までは入力規則で対応、そうでない場合プログラムで対応）","入力規則からプログラムでのチェックに変更\n勤務形態：常勤兼務の時"]
["MSG_CHK_ERR_P(18)","常勤兼務・非常勤で常勤専従人数の入力があります",null,14,"⑦1か月に数回の勤務の場合の１か月の勤務時間","Ｈ列","プログラム",null,null,">所定労働時間×４","MSG_CHK_ERR_P(25)","⑧勤務時間は「所定労働時間ｘ４」より小さい数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","入力規則では対応不可\n→プログラムで対応（1～176までは入力規則で対応、そうでない場合プログラムで対応）","入力規則からプログラムでのチェックに変更\n勤務形態：非常勤の時"]
["MSG_CHK_ERR_P(19)","⑦～⑩のうち該当する項目のみに入力してください(常勤兼務)",null,15,"⑦1か月に数回の勤務の場合の１か月の勤務時間","Ｈ列","プログラム",null,null,"≠小数点第２位以内","MSG_CHK_ERR_P(11)","小数点第２位以内の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","小数点以下の入力規則はできない為、チェックを追加","チェックの追加を確認\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(20)","⑦～⑩のうち該当する項目のみに入力してください(非常勤)",null,16,"⑧勤務時間が分けられない場合","Ｉ列・Ｊ列\n","プログラム",null,null,"I列・Ｊ列以外に記入がなく、\nI列・Ｊ列の両方に記入がない","MSG_CHK_ERR_P(13)","⑨人数は両方入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","H列・I列の整合性チェックを追加","チェックの追加を確認\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(21)","⑨人数は両方入力してください",null,17,"⑨当該職種の勤務割合","Ｋ列","プログラム",null,null,"≠小数点第3位以内","MSG_CHK_ERR_P(12)","小数点第３位以内の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","小数点以下の入力規則はできない為、チェックを追加","チェックの追加を確認\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(22)","該当職種における勤務時間がわからない場合は、換算数を⑨に入力してください",null,18,"⑥～⑨","G列-K列\n","プログラム",null,null,"未記入","MSG_CHK_ERR_P(14)","⑦～⑩が未入力です","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","※人数按分(I、J）が１つのみ入力されている場合は番号16のチェックで対応","③④⑤の入力がある場合\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(23)","換算数を⑩に入力してください",null,19,"⑥～⑨","G列-K列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(19)","⑦～⑩のうち該当する項目のみに入力してください(常勤兼務)","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：常勤兼務かつ⑦~⑩を\n　　　　　　　　二種類以上入力時"]
["MSG_CHK_ERR_P(24)","⑦勤務時間は所定労働時間より小さい数値を入力してください",null,20,"⑥～⑨","G列-K列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(20)","⑦～⑩のうち該当する項目のみに入力してください(非常勤)","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：非常勤かつ⑦~⑩を二種類以上入力時\nただし⑨（両方）入力時⑦or⑧の二種類入力はＯＫ"]
["MSG_CHK_ERR_P(25)","⑧勤務時間は「所定労働時間ｘ４」より小さい数値を入力してください",null,21,"⑤","Ｆ列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(15)","常勤専従の人数が未入力です","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：常勤専従かつ③④⑤入力時"]
["MSG_CHK_ERR_P(26)","⑦もしくは⑧に勤務時間を入力してください",null,22,"⑥～⑨","G列-K列","プログラム",null,null,"記入","MSG_CHK_ERR_P(16)","常勤専従は常勤専従人数のみ入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：常勤専従かつ③④⑤⑥に入力があり、⑦以降にも入力がある時"]
[null,null,null,23,"⑤","Ｆ列","プログラム",null,null,"記入","MSG_CHK_ERR_P(18)","常勤兼務・非常勤で常勤専従人数の入力があります","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：常勤専従or非常勤の時"]
[null,null,null,24,"⑧","Ｉ列・Ｊ列","プログラム",null,null,"未記入（片方）","MSG_CHK_ERR_P(21)","⑨人数は両方入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：非常勤かつ⑦or⑧で⑨が「ブランク」と「数値あり」の組み合わせで入力時\n"]
[null,null,null,25,"⑨","Ｋ列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(22)","該当職種における勤務時間がわからない場合は、換算数を⑨に入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","福祉は⑨Aに０の入力を許さない","勤務形態：常勤兼務かつ⑨（両方）に0入力時"]
[null,null,null,26,"⑨","Ｋ列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(23)","換算数を⑩に入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","福祉は⑨Aに０の入力を許さない","勤務形態：非常勤の時かつ⑦or⑧入力かつ⑨（両方）に0入力時"]
[null,null,null,27,"⑥⑦","G列-Ｈ列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(26)","⑦もしくは⑧に勤務時間を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：非常勤かつ⑨両方のみ入力時"]

{"sheet":"集計シート","index":9,"n_rows":14,"n_cols":82,"rows_kept":14,"cut":false,"hidden":true,"merged":[[2,6,2,10],[2,11,2,17],[3,7,3,8],[3,9,3,10],[3,12,3,14],[3,15,3,17]]}
["所定労働時間"]
[0,"※[計算シート」で指定した「所定労働時間」が32時間より小さい場合は「32時間」*4で補正される"]
[null,null,null,null,null,null,"転記情報",null,null,null,null,"集計算出値",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1","Err2","Err6",null,"Err4","Err5(所定時間）",null,null,null,null,null,null,null,null,null,null,"Err3",null,null,null,null,null,null,null,null,"バックアップ用ヘッダー"]
["集計インデックス",null,null,null,null,null,"専従","常勤兼務",null,"非常勤",null,"専従","常勤兼務",null,null,"非常勤",null,null,null,null,null,null,null,"集計用データ",null,"※うち数",null,null,null,null,null,null,null,"ロウデータ",null,null,null,null,null,null,null,null,null,null,null,"バックアップ用",null,null,null,null,null,"*フラグ1の時のみ、四捨五入する",null,"集計用データ",null,"※うち数",null,null,null,null,null,null,null,"ロウデータ",null,null,null,null,null,null,null,"この施設・事業所の利用人数","兼務する施設・事業所の利用人数"]
["票種","サービス種別","職種-資格","集計用職種","集計用資格","集計用資格2","人数","人数","換算数","人数","換算数","人数","人数","換算数","計算","人数","換算数","計算","性別","集計用Index1","集計用Index2","集計用Index3","予備",{"$f":"IF(AC6=\"Err1\",AC6,\"\")&IF(AD6=\"Err2\",AD6,\"\")&IF(AE6=\"Err6\",AE6,\"\")&IF(AS6=\"\",\"\",\"Err3\")&IF(AJ6=\"常勤専従\",\"\",IF(AG6=0,\"Err4\",\"\"))&IF($A$2=0,\"Err5\",\"\")","v":"Err1Err2Err6Err5"},{"$f":"IF(X6<>\"\",\"\",IF(AD6=\"該当資格なし\",\"\",IF(AL6=\"\",\"\",AL6&\"-\")&AC6&IF(AD6=0,\"\",\"-\"&AD6)&\"-\"&AJ6))","v":""},{"$f":"IF(X6<>\"\",\"\",IF(AD6=0,\"\",IF(AL6=\"\",\"\",AL6&\"-\")&AC6&\"-\"&AJ6))","v":""},{"$f":"IF(X6<>\"\",\"\",IF(AE6=\"該当資格なし\",\"\",IF(AE6=0,\"\",IF(AL6=\"\",\"\",AL6&\"-\")&AD6&\"-\"&AJ6)))","v":""},"予備",{"$f":"IF(ISERROR(VLOOKUP($AK6,$C$6:$F$31,2,0))=TRUE,\"Err1\",VLOOKUP($AK6,$C$6:$F$31,2,0))","v":"Err1"},{"$f":"IF(ISERROR(VLOOKUP($AK6,$C$6:$F$31,3,0))=TRUE,\"Err2\",VLOOKUP($AK6,$C$6:$F$31,3,0))","v":"Err2"},{"$f":"IF(ISERROR(VLOOKUP($AK6,$C$6:$F$31,4,0))=TRUE,\"Err6\",VLOOKUP($AK6,$C$6:$F$31,4,0))","v":"Err6"},"予備",{"$f":"IF(AN6<>0,AN6*4,IF(AO6<>0,AO6,IF(AP6*AQ6<>0,ROUND((AP6/(AP6+AQ6)),1)*$A$2,IF(AR6<>0,AR6*$A$2,0))))","v":0},"番号","備考","勤務形態","職種","性別","専従人数","時間①","時間②","時間③","時間③","時間④","エラー","時間①","時間②","時間③","時間③","時間④",{"$f":"AJ6&AK6&AL6&AV6&AW6","v":"常勤専従1施設長男"},{"$f":"IF(AJ6=\"非常勤\",IF(AX6=\"\",IF(AV6&AW6<>\"\",IF(AV6<>0,COUNTIF($AY$5:$AY$6,AY6),0),0),0),0)","v":0},null,"集計対象","集計用Index1","集計用Index2","集計用Index3","予備","職種","資格","資格2","予備","時間(標準化)","番号","備考","勤務形態","職種","性別","専従人数","時間①","時間②","時間③","時間③","時間④","エラー","時間①","時間②","時間③","時間③","時間④","特殊判断Idx","特殊判断Flg"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC6=\"Err1\",AC6,\"\")&IF(AD6=\"Err2\",AD6,\"\")&IF(AE6=\"Err6\",AE6,\"\")&IF(AS6=\"\",\"\",\"Err3\")&IF(AJ6=\"常勤専従\",\"\",IF(AG6=0,\"Err4\",\"\"))&IF($A$2=0,\"Err5\",\"\")","v":"Err1Err2Err6Err5"},{"$f":"IF(X6<>\"\",\"\",IF(AD6=\"該当資格なし\",\"\",IF(AL6=\"\",\"\",AL6&\"-\")&AC6&IF(AD6=0,\"\",\"-\"&AD6)&\"-\"&AJ6))","v":""},{"$f":"IF(X6<>\"\",\"\",IF(AD6=0,\"\",IF(AL6=\"\",\"\",AL6&\"-\")&AC6&\"-\"&AJ6))","v":""},{"$f":"IF(X6<>\"\",\"\",IF(AE6=\"該当資格なし\",\"\",IF(AE6=0,\"\",IF(AL6=\"\",\"\",AL6&\"-\")&AD6&\"-\"&AJ6)))","v":""},null,{"$f":"IF(ISERROR(VLOOKUP($AK6,$C$6:$F$29,2,0))=TRUE,\"Err1\",VLOOKUP($AK6,$C$6:$F$29,2,0))","v":"Err1"},{"$f":"IF(ISERROR(VLOOKUP($AK6,$C$6:$F$29,3,0))=TRUE,\"Err2\",VLOOKUP($AK6,$C$6:$F$29,3,0))","v":"Err2"},{"$f":"IF(ISERROR(VLOOKUP($AK6,$C$6:$F$29,4,0))=TRUE,\"Err6\",VLOOKUP($AK6,$C$6:$F$29,4,0))","v":"Err6"},null,{"$f":"IF(AN6<>0,AN6*4,IF(AO6<>0,AO6,IF(AP6*AQ6<>0,ROUND((AP6/(AP6+AQ6)),1)*$A$2,IF(AR6<>0,AR6*$A$2,0))))","v":0},1,"Aさん","常勤専従","1施設長","男",1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ6&AK6&AL6&AV6&AW6","v":"常勤専従1施設長男"},{"$f":"IF(AJ6=\"非常勤\",IF(AX6=\"\",IF(AV6&AW6<>\"\",IF(AV6<>0,COUNTIF($AY$6:$AY$14,AY6),0),0),0),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1Err2Err6Err5","","","",null,"Err1","Err2","Err6",null,80,2,"Bさん","非常勤","5保健師・看護師","女",null,20,null,null,null,null,null,20,null,null,null,null,"非常勤5保健師・看護師女",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1Err2Err6Err5","","","",null,"Err1","Err2","Err6",null,10,3,"Cさん","非常勤","3保育補助者-該当資格なし","女",null,null,10,null,null,null,null,null,10,null,null,null,"非常勤3保育補助者-該当資格なし女",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1Err2Err6Err5","","","",null,"Err1","Err2","Err6",null,40,4,"Dさん","常勤兼務","2保育士-該当資格なし","男",null,10,null,null,null,null,null,10,null,null,null,null,"常勤兼務2保育士-該当資格なし男",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1Err2Err6Err5","","","",null,"Err1","Err2","Err6",null,120,5,"Dさん","常勤兼務","8事務員","男",null,30,null,null,null,null,null,30,null,null,null,null,"常勤兼務8事務員男",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1Err2Err6Err5","","","",null,"Err1","Err2","Err6",null,60,6,"Eさん","非常勤","6栄養士-該当資格なし","女",null,15,null,null,null,null,null,15,null,null,null,null,"非常勤6栄養士-該当資格なし女",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1Err2Err6Err5","","","",null,"Err1","Err2","Err6",null,80,7,"Eさん","非常勤","7調理員","女",null,20,null,null,null,null,null,20,null,null,null,null,"非常勤7調理員女",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1Err2Err6Err4Err5","","","",null,"Err1","Err2","Err6",null,0,8,"Fさん","常勤兼務","7調理員","女",null,null,null,40,25,null,null,null,null,40,25,null,"常勤兼務7調理員女4025",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Err1Err2Err6Err4Err5","","","",null,"Err1","Err2","Err6",null,0,9,"Gさん","非常勤","2保育士-該当資格なし","男",null,null,null,null,null,0.6,null,30,null,40,10,null,"非常勤2保育士-該当資格なし男4010",1]

{"sheet":"エラーチェック","index":10,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["2024.5.14"]
[null,"勤務時間①-④の入力値は①＞②＞③＞④　※チェック時に優先度の高い有効値がある場合は、それより低い優先度の値のチェックは不要とする"]
[]
["エラーコード一覧",null,null,"エラーチェック　入力規則"]
["MSGCD","エラー表示メッセージ",null,"番号","項目","対象列\nセル","チェック種類","入力値種類","スタイル","チェック内容","MSGCD","エラー表示メッセージ","表示場所","集計結果","備考","確認"]
["MSG_CHK_ERR_K(1)","リストから選択してください",null,1,"サービス種別","Ｈ7","入力規則","リスト","停止","選択肢以外","MSG_CHK_ERR_K(1)",{"$f":"IF(ISERROR(VLOOKUP(K6,$A$6:$B$38,2,0))=TRUE,\"\",VLOOKUP(K6,$A$6:$B$38,2,0))","v":"リストから選択してください"},"メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(2)","1週間の所定労働時間は32～44の数値で入力してください",null,2,"１週間の所定労働時間","C9","入力規則","小数点数","停止","≠小数\n範囲：1-44","MSG_CHK_ERR_K(2)","1週間の所定労働時間は32～44の数値で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(3)","１週間の勤務時間は1～44の数値で入力してください",null,3,"勤務形態","C列","入力規則","リスト","停止","選択肢以外","MSG_CHK_ERR_K(9)","勤務形態はリストから選択してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(4)","人数は0～99999の整数で入力してください",null,4,"職種","D列","入力規則","リスト","停止","選択肢以外","MSG_CHK_ERR_P(7)","職種はリストから選択してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(5)","１職種あたりの換算数は0.1～1.0の数値で入力してください",null,5,"性別","E列","入力規則","リスト","停止","未記入","MSG_CHK_ERR_K(8)","性別はリストから選択してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(6)","1か月の勤務時間は1～176の数値で入力してください",null,6,"⑤常勤専従人数","Ｆ列","入力規則","整数","停止","≠整数\n範囲：1～99999","MSG_CHK_ERR_K(7)","人数は1～99999の整数で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(7)","人数は1～99999の整数で入力してください",null,7,"⑥この施設での１週間の勤務時間","G列","入力規則","小数点数","停止","≠小数\n範囲：1-44","MSG_CHK_ERR_K(3)","１週間の勤務時間は1～44の数値で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","所定労働時間とのチェックはプログラムで対応\n値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(8)","性別はリストから選択してください",null,8,"⑦1か月に数回の勤務の場合の１か月の勤務時間","H列","入力規則","小数点数","停止","≠小数\n範囲：1-176","MSG_CHK_ERR_K(6)","1か月の勤務時間は1～176の数値で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","所定労働時間とのチェックはプログラムで対応\n値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_K(9)","勤務形態はリストから選択してください",null,9,"⑧勤務時間が分けられない場合","I列・J列","入力規則","整数","停止","≠整数\n範囲：0～99999","MSG_CHK_ERR_K(4)","人数は0～99999の整数で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","整数のみ 介護（I、J列）、福祉（I列）\n値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
[null,null,null,10,"⑧勤務時間が分けられない場合","I列","入力規則","整数","停止","≠整数\n範囲：1～99999","MSG_CHK_ERR_K(7)","人数は1～99999の整数で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","整数のみ 福祉\n値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
[null,null,null,11,"⑨当該職種の換算数","K列","入力規則","小数点数","停止","＞１．０\n範囲：0.1～1","MSG_CHK_ERR_K(5)","１職種あたりの換算数は0.1～1.0の数値で入力してください","メッセージボックス","メッセージボックスにエラーが表示される場合→入力自体不可\nL列にエラー表示→該当行は集計結果から除外","値をペーストされた場合は、L列 -エラー該当行にメッセージ表示","メッセージ確認"]
["MSG_CHK_ERR_P(1)","エラーが発生しています　(集計不可)"]
["MSG_CHK_ERR_P(2)","エラーが発生しています　(集計結果はエラー行を除外しています)"]
["MSG_CHK_ERR_P(3)","サービス種別を選択してください",null,"エラーチェック　プログラム"]
["MSG_CHK_ERR_P(4)","1週間の所定労働時間は32～44の数値で入力してください",null,"番号","項目","対象列\nセル","チェック種類","入力値種類","スタイル","チェック内容","MSGCD","エラー表示メッセージ","表示場所","集計結果","備考","確認"]
["MSG_CHK_ERR_P(5)","勤務形態をリストから選択してください",null,1,"全体","全体","プログラム",null,null,"エラーが1つ以上発生している場合\n※集計不可のエラーが含まれている場合","MSG_CHK_ERR_P(1)",{"$f":"IF(ISERROR(VLOOKUP(K21,$A$6:$B$46,2,0))=TRUE,\"\",VLOOKUP(K21,$A$6:$B$46,2,0))","v":"エラーが発生しています　(集計不可)"},"セル「G9」","全ての集計結果が算出不可","プログラムチェック結果で1つ以上のエラーが発生している場合に表示する\n「サービス種別」・「1週間の所定労働時間」のブランクエラーを含む場合","メッセージ確認"]
["MSG_CHK_ERR_P(6)","職種をリストから選択してください",null,2,"全体","全体","プログラム",null,null,"エラーが1つ以上発生している場合\n※集計不可のエラーが含まれていない場合","MSG_CHK_ERR_P(2)",{"$f":"IF(ISERROR(VLOOKUP(K22,$A$6:$B$46,2,0))=TRUE,\"\",VLOOKUP(K22,$A$6:$B$46,2,0))","v":"エラーが発生しています　(集計結果はエラー行を除外しています)"},"セル「G9」","該当行は集計結果から除外","プログラムチェック結果で1つ以上のエラーが発生している場合に表示する\n※行単位のエラーのみの場合","メッセージ確認"]
["MSG_CHK_ERR_P(7)","職種はリストから選択してください",null,3,"サービス種別","Ｈ7","プログラム",null,null,"未記入","MSG_CHK_ERR_P(3)","サービス種別を選択してください","セル「J7」","全ての集計結果が算出不可","サービス種別が複数ある調査票種のみ\n※サービス種別の選択が不要な票種は不要","サービス種別がブランクの場合の集計ができない旨を確認"]
["MSG_CHK_ERR_P(8)","性別をリストから選択してください",null,4,"１週間の所定労働時間","C9","プログラム",null,null,"未記入","MSG_CHK_ERR_P(4)","1週間の所定労働時間は32～44の数値で入力してください","セル「C10」","全ての集計結果が算出不可",null,"所定労働時間がブランクの場合の集計ができない旨を確認"]
["MSG_CHK_ERR_P(9)","⑥勤務時間は所定労働時間以下の数値を入力してください",null,5,"１週間の所定労働時間","C9","プログラム",null,null,"≠小数点第２位以内","MSG_CHK_ERR_P(11)","小数点第２位以内の数値を入力してください","セル「C10」","全ての集計結果が算出不可",null,"所定労働時間がブランクの場合の集計ができない旨を確認"]
["MSG_CHK_ERR_P(10)","⑦勤務時間は「所定労働時間ｘ４」以下の数値を入力してください",null,6,"勤務形態","C列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(5)","勤務形態をリストから選択してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"メッセージ確認"]
["MSG_CHK_ERR_P(11)","小数点第２位以内の数値を入力してください",null,7,"職種","D列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(6)","職種をリストから選択してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態入力時"]
["MSG_CHK_ERR_P(12)","小数点第３位以内の数値を入力してください",null,8,"職種","D列","プログラム",null,null,"選択されたサービス種別に該当しない職種の場合","MSG_CHK_ERR_P(7)","職種はリストから選択してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","サービス種別を後で変更したケースに対応","チェックの追加を確認\n勤務形態入力時"]
["MSG_CHK_ERR_P(13)","⑧人数は両方入力してください",null,9,"性別","E列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(8)","性別をリストから選択してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","性別の選択が不要な票はチェック不要\n※列幅を0で非表示対応とする","2021.から実稼働"]
["MSG_CHK_ERR_P(14)","⑥～⑨が未入力です",null,10,"⑥この施設での１週間の勤務時間","Ｇ列","プログラム",null,null,"≧所定労働時間","MSG_CHK_ERR_P(9)","⑥勤務時間は所定労働時間以下の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","入力規則では対応不可\n→プログラムで対応（1～44までは入力規則で対応、そうでない場合プログラムで対応）","入力規則からプログラムでのチェックに変更\n勤務形態：常勤兼務の時"]
["MSG_CHK_ERR_P(15)","常勤専従の人数が未入力です",null,11,"⑥この施設での１週間の勤務時間","Ｇ列","プログラム",null,null,">所定労働時間","MSG_CHK_ERR_P(24)","⑥勤務時間は所定労働時間より小さい数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","入力規則では対応不可\n→プログラムで対応（1～44までは入力規則で対応、そうでない場合プログラムで対応）","入力規則からプログラムでのチェックに変更\n勤務形態：非常勤の時"]
["MSG_CHK_ERR_P(16)","常勤専従は常勤専従人数のみ入力してください",null,12,"⑥この施設での１週間の勤務時間","Ｇ列","プログラム",null,null,"≠小数点第２位以内","MSG_CHK_ERR_P(11)","小数点第２位以内の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","小数点以下の入力規則はできない為、チェックを追加","チェックの追加を確認\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(17)","常勤専従は⑥～⑨の入力は不要です",null,13,"⑦1か月に数回の勤務の場合の１か月の勤務時間","Ｈ列","プログラム",null,null,"≧所定労働時間×４","MSG_CHK_ERR_P(10)","⑦勤務時間は「所定労働時間ｘ４」以下の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","入力規則では対応不可\n→プログラムで対応（1～176までは入力規則で対応、そうでない場合プログラムで対応）","入力規則からプログラムでのチェックに変更\n勤務形態：常勤兼務の時"]
["MSG_CHK_ERR_P(18)","常勤兼務・非常勤で常勤専従人数の入力があります",null,14,"⑦1か月に数回の勤務の場合の１か月の勤務時間","Ｈ列","プログラム",null,null,">所定労働時間×４","MSG_CHK_ERR_P(25)","⑦勤務時間は「所定労働時間ｘ４」より小さい数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","入力規則では対応不可\n→プログラムで対応（1～176までは入力規則で対応、そうでない場合プログラムで対応）","入力規則からプログラムでのチェックに変更\n勤務形態：非常勤の時"]
["MSG_CHK_ERR_P(19)","⑥～⑨のうち該当する項目のみに入力してください(常勤兼務)",null,15,"⑦1か月に数回の勤務の場合の１か月の勤務時間","Ｈ列","プログラム",null,null,"≠小数点第２位以内","MSG_CHK_ERR_P(11)","小数点第２位以内の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","小数点以下の入力規則はできない為、チェックを追加","チェックの追加を確認\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(20)","⑥～⑨のうち該当する項目のみに入力してください(非常勤)",null,16,"⑧勤務時間が分けられない場合","Ｉ列・Ｊ列\n","プログラム",null,null,"I列・Ｊ列以外に記入がなく、\nI列・Ｊ列の両方に記入がない","MSG_CHK_ERR_P(13)","⑧人数は両方入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","H列・I列の整合性チェックを追加","チェックの追加を確認\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(21)","⑧人数は両方入力してください",null,17,"⑨当該職種の勤務割合","Ｋ列","プログラム",null,null,"≠小数点第3位以内","MSG_CHK_ERR_P(12)","小数点第３位以内の数値を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","小数点以下の入力規則はできない為、チェックを追加","チェックの追加を確認\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(22)","該当職種における勤務時間がわからない場合は、換算数を⑨に入力してください",null,18,"⑥～⑨","G列-K列\n","プログラム",null,null,"未記入","MSG_CHK_ERR_P(14)","⑥～⑨が未入力です","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","※人数按分(I、J）が１つのみ入力されている場合は番号16のチェックで対応","③④の入力がある場合\n勤務形態：常勤兼務or非常勤の時"]
["MSG_CHK_ERR_P(23)","換算数を⑨に入力してください",null,19,"⑥～⑨","G列-K列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(19)","⑥～⑨のうち該当する項目のみに入力してください(常勤兼務)","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：常勤兼務かつ⑥~⑨を\n　　　　　　　　二種類以上入力時"]
["MSG_CHK_ERR_P(24)","⑥勤務時間は所定労働時間より小さい数値を入力してください",null,20,"⑥～⑨","G列-K列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(20)","⑥～⑨のうち該当する項目のみに入力してください(非常勤)","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：非常勤かつ⑥~⑨を二種類以上入力時\nただし⑧（両方）入力時⑥or⑦の二種類入力はＯＫ"]
["MSG_CHK_ERR_P(25)","⑦勤務時間は「所定労働時間ｘ４」より小さい数値を入力してください",null,21,"⑤","Ｆ列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(15)","常勤専従の人数が未入力です","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：常勤専従かつ③④入力時"]
["MSG_CHK_ERR_P(26)","⑥もしくは⑦に勤務時間を入力してください",null,22,"⑥～⑨","G列-K列","プログラム",null,null,"記入","MSG_CHK_ERR_P(16)","常勤専従は常勤専従人数のみ入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：常勤専従かつ③④⑤に入力があり、⑥以降にも入力がある時"]
[null,null,null,23,"⑤","Ｆ列","プログラム",null,null,"記入","MSG_CHK_ERR_P(18)","常勤兼務・非常勤で常勤専従人数の入力があります","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：常勤専従or非常勤の時"]
[null,null,null,24,"⑧","Ｉ列・Ｊ列","プログラム",null,null,"未記入（片方）","MSG_CHK_ERR_P(21)","⑧人数は両方入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：非常勤かつ⑥or⑦で⑧が「ブランク」と「数値あり」の組み合わせで入力時\n"]
[null,null,null,25,"⑨","Ｋ列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(22)","該当職種における勤務時間がわからない場合は、換算数を⑨に入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","福祉は⑧Aに０の入力を許さない","勤務形態：常勤兼務かつ⑧（両方）に0入力時"]
[null,null,null,26,"⑨","Ｋ列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(23)","換算数を⑨に入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外","福祉は⑧Aに０の入力を許さない","勤務形態：非常勤の時かつ⑥or⑦入力かつ⑧（両方）に0入力時"]
[null,null,null,27,"⑥⑦","G列-Ｈ列","プログラム",null,null,"未記入","MSG_CHK_ERR_P(26)","⑥もしくは⑦に勤務時間を入力してください","L列 -エラー該当行","L列にエラー表示\n→該当行は集計結果から除外",null,"勤務形態：非常勤かつ⑧両方のみ入力時"]